create external table jms_dm.dm_spec_waybill_detail_dt 
(
waybill_no              string COMMENT '运单' ,
input_date              string comment '录入日期',
input_time              string COMMENT '录入时间' ,
business_type_code      string COMMENT '业务类型code' ,
business_type_name      string COMMENT '业务类型名称' ,
business_type_name_en   string COMMENT '业务类型英文名称' ,
input_network_id        string COMMENT '录入网点id' ,
input_network_code      string COMMENT '录入网点code' ,
input_network_name      string COMMENT '录入网点名称' ,
agent_code              string COMMENT '代理区编码' ,
agent_name              string COMMENT '代理区名称' ,
brand_id                string COMMENT '品牌id' ,
brand_name              string COMMENT '品牌名称' ,
remind_cnt              bigint COMMENT '提醒量' )
comment '特殊件明细'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_spec_waybill_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
